Model Table ORGANIZATION SITE
This model dimension represents sites (contracts) and is based on the IFS
Cloud dimension DIM_SITE. All models that refer to this dimension will
have the attributes and hierarchies as described below.
Attributes
| Attribute |
Description (where applicable) |
| Company Code | The identity of the COMPANY referenced by the a site (contract). |
| SITE_EQ_COUNT | |
| SITE_TX | |
| Site | Key. Defined as CODE + ' - ' + DESCRIPTION, i.e. site and its description. |
| Site Code | The CODE of the dimension, i.e. site |
| Site Description | The site DESCRIPTION |
| Site Description Code | Defined as DESCRIPTION + ' - ' + CODE, ie. site description and the site |
| Hierarchy |
Level |
| SiteHy | |
| Company Code |
| Site |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| ORGANIZATION SITE | DIM_SITE_TM | DIM_SITE_BI | DIM_SITE | On Line |